package com.example.billbillbangumi;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class MyDatabaseHelper extends SQLiteOpenHelper {
    public static final String CREATE_Bangumi="create table bangumi("
            +"id integer primary key autoincrement,"
            +"name text,"
            +"starttime text,"
            +"updatetime text,"
            +"attention text)";
    public static final String CREATE_Id="create table id("
            +"id text primary key,"
            +"password text)";
    private Context mContext;
    public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory,int version){
        super(context,name,factory,version);
        mContext=context;
    }
    @Override
    public void onCreate(SQLiteDatabase db){
        db.execSQL(CREATE_Bangumi);
        db.execSQL(CREATE_Id);
        Toast.makeText(mContext,"Create succeeded",Toast.LENGTH_SHORT).show();
    }
    @Override
    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
        db.execSQL("drop table if exists bangumi");
        db.execSQL("drop table if exists id");
        onCreate(db);

    }
}
